EMT Practice Test

1. Question Content...

---

Question1: Given the following grocery store orders:

If a query is made to the table with the following logic:
Order_Total > 132 OR (Order Total >= 25 AND Order_Total < 74)
Which of the following is the number of orders that will be returned by the query?

Question2: Under which of the following circumstances should the null hypothesis be accepted when a = 0.05?

Question3: Which of the following BEST describes the issue in which character values are mixed with integer values in a data set column?

Question4: Encryption is a mechanism for protecting data.
When should encryption be applied to data?
Choose the best answer.

Question5: Refer to the exhibit.
Given the following:

Which of the following is the most important thing for an analyst to do when transforming the table for a trend analysis?

Question6: An analyst is designing a dashboard to determine which site has the highest percentage of new customers. The analyst must choose an appropriate chart to include in the dashboard. The following data is available:

Which of the following types of charts should be considered to BEST display the data?

Question7: Refer to exhibit.

Which of the following summary statements upholds integrity in data reporting?

Question8: Consider the following dataset which contains information about houses that are for sale:

Which of the following string manipulation commands will combine the address and region name columns to create a full address?
full_address------------------------- 85 Turner St, Northern Metropolitan 25 Bloomburg St, Northern Metropolitan 5 Charles St, Northern Metropolitan 40 Federation La, Northern Metropolitan 55a Park St, Northern Metropolitan

Question9: Given the diagram below:

Which of the following steps is missing?

Question10: An analyst develops an IT document and needs to describe the technical terms used in the document. Which of the following is where the analyst should include descriptions of the technical terms?

Question11: Which of the following is an example of structured data?

Question12: An analyst has written the following code:
SELECT *
FROM Cust_table
WHERE age > 60 AND City = "New York"
Which of the following criteria is the analyst retrieving?

Question13: Which of the following is a best practice when updating a legacy data source?

Question14: An analyst needs to provide a chart to identify the composition between the categories of the survey response data set:

Which of the following charts would be BEST to use?

Question15: An analyst needs to create an analytics dashboard for an employee intranet site to improve the search functionality, display relevant information, and maintain an updated FAQ page. Which of the following visualizations would best represent what employees are searching for?

Question16: Five dogs have the following heights in millimeters:
300,430, 170, 470, 600
Which of the following is the standard deviation for the five dogs?

Question17: A data analyst has a set with more than 40.000 rows in the sample schema below:

The analyst would like to create one column that contains the customers' birth dates. Which of the following data quality dimensions would BEST explain the reason for compilation?

Question18: Which of the following would a data analyst look for first if 100% participation is needed on survey results?

Question19: An analyst has conducted a review of business questions. Which of the following should the analyst do next to conduct an analysis?

Question20: Which of the ing is the correct ion for a tab-delimited spre file?

Question21: A web developer wants to ensure that malicious users can't type SQL statements when they asked for input, like their username/userid.
Which of the following query optimization techniques would effectively prevent SQL Injection attacks?

Question22: Refer to the exhibit.
Given the image below:

The data should be cleaned because of the presence of:

Question23: A marketing analytics team received customer transaction data from two different sources. The data is complete and accurate; however, the field names appear to be inconsistent. Given the following tables:

Which of the following is considered best practice if the team wants to consolidate the files and conduct further analysis?

Question24: A JSON file is an example of:

Question25: Refer to the exhibit.

Which of the following logical statements results in Table B?

Question26: What category of data stewardship work is focused on ensuring that the organization respects the wishes of data subjects?

Question27: Daniel is using the structured Query language to work with data stored in relational database.
He would like to add several new rows to a database table.
What command should he use?

Question28: Which of following is a non-relational database?

Question29: What would be an example of an acceptable form of primary identification for the Data+ exam?

Question30: Which one of the following is a measure of dispersion?

Question31: A data analyst is attempting to understand how ice cream consumption is affected by different attributes. such as cost, temperature. and income level. Which of the following regression analyses should the data analyst perform to understand this relationship?

Question32: A data analyst wants to create "Income Categories" that would be calculated based on the existing variable "Income". The "Income Categories" would be as follows:
Income category 1: less than $1.
Income category 2: more than $1 and less than $20,000.
Income category 3: more than $20,001 and less than $40,000.
Income category 4: more than $40,001.
Which of the following data manipulation techniques should the data analyst use to create "Income Categories"?

Question33: An analyst has generated a report that includes the number of months in the first two quarters of 2019 when sales exceeded $50,000:

Which of the following functions did the analyst use to generate the data in the Sales_indicator column?

Question34: A sales team wants visibility of current sales numbers, pipeline, and team performance. The team would also like to see calculations of individuals' earned commissions and projected commissions based on sales, but they want that information to be kept confidential. Which of the following would be the BEST way to provide this visibility?

Question35: A military commander would like to see the health scorecards of the troops daily and filter them based on gender and rank. Considering this data is PHI, which of the following would be the best way for the commander to view the information?

Question36: A database consists of one fact table that is composed of multiple dimensions. Depending on the dimension, each one can be represented by a denormalized table or multiple normalized tables. This structure is an example of a:

Question37: Which of the following is a non-parametric test?

Question38: A data scientist wants to see which products make the most money and which products attract the most customer purchasing interest in their company.
Which of the following data manipulation techniques would he use to obtain this information?

Question39: Which of the following is an example of a flat file?

Question40: An e-commerce company recently tested a new website layout. The website was tested by a test group of customers, and an old website was presented to a control group. The table below shows the percentage of users in each group who made purchases on the websites:

Which of the following conclusions is accurate at a 95% confidence interval?

Question41: A company's marketing department wants to do a promotional campaign next month. A data analyst on the team has been asked to perform customer segmentation, looking at how recently a customer bought the product, at what frequency, and at what value. Which of the following types of analysis would this practice be considered?

Question42: Refer to the exhibit.
Given the following data tables:

Which of the following MDM processes needs to take place FIRST?

Question43: What SQL command is used to delete an entire table from a database?

Question44: During data profiling, an analyst decides to recode the status column in the following data set:

Which of the following data concerns explains why the analyst wants to take this action?

Question45: An analyst needs to join two tables of data together for analysis. All the names and cities in the first table should be joined with the corresponding ages in the second table, if applicable.

Which of the following is the correct join the analyst should complete. and how many total rows will be in one table?

Question46: Which of the following is a KPI metric for tracking sales performance?

Question47: Which of the following reports can be used when insight into operational performance is needed each Wednesday?

Question48: Given the following tables:

Which of the following will be the dimensions from a FULL JOIN of the tables above?

Question49: Mario works with a group of R programmers tasked with copying data from an accounting system into a data warehouse.
In what phase are the group's R skills most relevant?

Question50: A data analyst is performing a data merge within a spreadsheet using the tables below:

The analyst is attempting to pull the addresses from Table 2 into Table 1 using the last names and is receiving an error message. Which of the following steps can the analyst perform to fix the error?

Question51: The number of phone calls that the call center receives in a day is an example of:

Question52: Which of the following is a control measure for preventing a data breach?

Question53: An analyst is working with the income data of suburban families in the United States. The data set has a lot of outliers, and the analyst needs to provide a measure that represents the typical income. Which of the following would BEST fulfill the analyst's goal?

Question54: Which of the following statements would be used to append two tables that have the same number of columns?

Question55: Standardized tests are given to students in the middle of each month, and the results are ready by the end of the month. The superintendent needs a quick view of test performance. Which of the following would be the best recommendation to meet the superintendent's requirements?

Question56: Which of the following contains alphanumeric values?

Question57: A data analyst for a media company needs to determine the most popular movie genre. Given the table below:

Which of the following must be done to the Genre column before this task can be completed?

Question58: A financial institution is reporting on sales performance to a company at the account level. Due to the sensitive nature of the government the does il with, some account information is not shown. Which of the following fields should be masked?

Question59: Refer to the exhibit.
Given the diagram below:

Which of the following types of sampling is depicted in the image?

Question60: A data analyst is designing a dashboard that will provide a story of sales and determine which site is providing the highest sales volume per customer. The analyst must choose an appropriate chart to include in the dashboard. The following data is available:

Which of the following types of charts should be considered?

Question61: Alex wants to use data from his corporate sale, CRM, and shipping systems to try and predict future sales.
Which of the following systems is the most appropriate?
Choose the best answer.

Question62: An analyst runs a report on a daily basis, and the number of datapoints must be validated before the data can be analyzed. The number of datapoints increases each day by approximately 20% of the total number from the day before. On a given day, the number of datapoints was 8,798. Which of the following should be the total number of datapoints on the next day?

Question63: A data analyst must fulfill a request for information that is needed weekly and should be automatically emailed to a specific set of users. Which of the following types of reports should the analyst recommend?

Question64: Refer to the exhibit.
Given the diagram below:

Which of the following data schemas shown?

Question65: Which of the following data manipulation techniques is an example of a logical function?

Question66: A company's human resources department has asked a data analyst to categorize the income of all employees into five salary bands:

Which of the following types of functions would be the most appropriate to use?

Question67: Each month an analyst needs to execute a data pull for the two prior months. Which of the following is the most efficient function for the analyst to use?

Question68: You are working with a dataset and want to change the names of categories that you used for different types of books.
What term best describes this action?

Question69: Which of the following data types would a telephone number formatted as XXX-XXX-XXXX be considered?

Question70: A recurring event is being stored in two databases that are housed in different geographical locations. A data analyst notices the event is being logged three hours earlier in one database than in the other database. Which of the following is the MOST likely cause of the issue?

Question71: Analytics reports should follow corporate style guidelines.

Question72: A data analyst has received a data set that contains actual and projected sales for the fourth quarter of 2019. Which of the following statistical methods should the analyst use to find the measure of dispersion?

Question73: Which of the following is an example of a data-mining ETL tool?

Question74: You should always choose the analytics tool that is most appropriate for any given situation, even if that means acquiring a new tool.

Question75: Which of the following is the best description of the term "data governance"?

Question76: A county in Illinois is conducting a survey to determine the mean annual income per household. The county is 427sq mi (2.65q km). Which of the following sampling methods would MOST likely result in a representative sample?

Question77: Samantha needs to share a list of her organization's top 50 customers with the VP of sales.
She would like to include the name of the customer, the business they represent, their contact information, and their total sales over the past year.
The VP does not have any specialized analytics skills or software but would like to make some personal notes on the dataset.
What would be the best tool for Samantha to use to share this information?

Question78: Which of the following data cleansing issues will be fixed when a DISTINCT function is applied?

Question79: An analyst is reviewing the following data:
Car ID Speed
1231 55
5664 36
5644 18
6505 67
5464 36
6456 38
Which of the following should the analyst include in the measures of central tendency for speed?

Question80: Which of the following best describes how discrete data differs from continuous data?

Question81: A data analyst is asked on the morning of April 9, 2020, to create a sales report that identifies sales year to date. The daily sales data is current through the end of the day. Which of the following date ranges should be on the report?

Question82: Joseph is interpreting a left skewed distribution of test scores. Joe scored at the mean, Alfonso scored at the median, and gaby scored and the end of the tail.
Who had the highest score?

Question83: A data analyst received the information in the table below from a recently completed marketing campaign:

Which of the following is the total order conversion rate?

Question84: Refer to the exhibit.
A data analyst needs to calculate the mean for Q1 sales using the data set below:

Which of the following is the mean?

Question85: Amanda needs to create a dashboard that will draw information from many other data sources and present it to business leaders.
Which one of the following tools is least likely to meet her needs?

Question86: An analyst modified a data set that had a number of issues. Given the original and modified versions:

Which of the following data manipulation techniques did the analyst use?

Question87: A survey asks participants to rate a company on a scale of one to ten. Which of the following best describes the rating variable?

Question88: A cereal manufacturer wants to determine whether the sugar content of its cereal has increased over the years. Which of the following is the appropriate descriptive statistic to use?

Question89: Which of the following value is the measure of dispersion "range" between the scores of ten students in a test.
The scores of ten students in a test are 17, 23, 30, 36, 45, 51, 58, 66, 72, 77.

Question90: The process of performing initial investigations on data to spot outliers, discover patterns, and test assumptions with statistical insight and graphical visualization is called:

Question91: Jenny wants to study the academic performance of undergraduate sophomores and wants to determine the average grade point average at different points during an academic year.
What best describes the data set she needs?

Question92: Which of the following is a common data analytics tool that is also used as an interpreted, high-level, general-purpose programming language?

Question93: While reviewing survey data, an analyst notices respondents entered "Jan," "January," and "01" as responses for the month of January. Which of the following steps should be taken to ensure data consistency?

Question94: Which of the following is an example of a discrete data type?

Question95: Which of the following would be used to store unstructured data from different sources?

Question96: An analyst is required to run a text analysis of data that is found in articles from a digital news outlet. Which of the following would be the BEST technique for the analyst to apply to acquire the data?

Question97: A data analyst needs to create a data visualization that aids in un the cumulative impact of sequentially introduced values that are positive or negative. Which of the following data visualization methods should the analyst use?

Question98: A data analyst is creating a dashboard and trying to identify the type of information that should be included. Which of the following should the analyst consider first?

Question99: You are working with a professional statistician to perform an analysis and would like to use a statistics package.
Which one of the following would be the most appropriate?

Question100: An employer needs to maintain adequate office staffing during the winter and wants to track storm dat a. Which of the following data collection methods should the employer use?

Question101: A customer's telephone number is in the format 123-456-7890. Which of the following data types is used for the phone number?

Question102: Refer to the exhibit.
Given the following graph:

Which of the following summary statements upholds integrity in data reporting?

Question103: A data analyst needs to present the results of an online marketing campaign to the marketing manager. The manager wants to see the most important KPIs and measure the return on marketing investment. Which of the following should the data analyst use to BEST communicate this information to the manager?

Question104: An analyst needs to provide a chart to identify the composition between the categories of the survey response data set:

Which of the following charts would be BEST to use?

Question105: You would like to measure how well an organization is achieving its goals.
What type of analysis should you perform?

Question106: A data analyst has been asked to create a daily manufacturing report for the floor manager Which of the following metrics should be included in the report?

Question107: Which one of the following programming languages is specifically designed for use in analytics applications?

Question108: Which of the following would be the best way to identify multicollinear attributes in a data set?

Question109: Which of the following BEST describes standard deviation?

Question110: Consider this dataset showing the retirement age of 11 people, in whole years:
54, 54, 54, 55, 56, 57, 57, 58, 58, 60, 60
This tables show a simple frequency distribution of the retirement age data.

Question111: Refer to the exhibit.
Given the following data:

Which of the following BEST describes the data set?

Question112: A data analyst needs to collect a similar proportion of data from every state. Which of the following sampling methods would be the most appropriate?